package com.zhen.servlet;

import com.zhen.utils.JdbcUtils;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;

public class UserUpdateServlet extends HttpServlet {
    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        // 1. 取值
        String name = req.getParameter("addName");
        String username = req.getParameter("addUsername");
        String id = req.getParameter("addId");
        // 2. 储值
        if (id != null && !"null".equals(id)) {
            // 存在 id，执行更新
            System.out.println("修改用户id="+id);
            String sql = "UPDATE `user` SET `name` = ?, username = ? WHERE id = ?";
            JdbcUtils.modify(sql, name, username, id);
        } else {
            // 不存在 id，执行插入
            System.out.println("插入用户，username="+username+"name="+name);
            String sql = "INSERT INTO `user` (username, `password`, `name`) VALUES(?, MD5('123456'), ?)";
            JdbcUtils.modify(sql, username, name);
        }
        // 3. 跳转
        resp.sendRedirect("/zhen/user-list.jsp");

    }

    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        doGet(req, resp);
    }
}
